package com.liu.dao;

import com.liu.pojo.Book;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

public interface BookDao extends JpaRepository<Book, Integer> {
            List<Book> getBooksByAuthorStartingWith(String author);//where author like '?%'
            List<Book> getBooksByPriceGreaterThan(Float price);//where price >?
            @Query(value ="select * from t_book where id=(select max(id) from t_book)",nativeQuery=true)
            Book getMaxIdBook();
            @Query("select b from t_book b where b.id>:id and b.author=:author")
            List<Book> getBookByIdAndAuthor(@Param("author")String author,@Param("id") Integer id);
            @Query("select b from t_book b where b.id<2 and b.name like %?1%")
            List<Book> getBooksByIdAndName(String name,Integer id);

}
